package com.ytjj.qmyx.admin.model.excel.demo3;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;
import lombok.Data;
import org.apache.poi.ss.usermodel.HorizontalAlignment;

import java.net.URL;
import java.util.List;

/**
 * @author jiawei
 * @date 2023年11月23日 14:14
 * @describe 导出excel实体
 */
@Data
@ContentRowHeight(20)
@HeadRowHeight(20)
@ColumnWidth(25)
@HeadStyle(horizontalAlignment = HorizontalAlignment.CENTER)
@ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER)
public class ReimbursementOrdersExcel {

    @ExcelProperty(value = "提单时间")
    private String createTime;

    @ExcelProperty(value = "报销单号")
    private String reimbursementNo;

    @ExcelProperty(value = "关联的订单号")
    private String childOrderNo;

    @ExcelProperty(value = "报销次数")
    private String reimbursementTimes;

    @ExcelProperty(value = "收件人姓名")
    private String userName;

    @ExcelProperty(value = "收件人电话")
    private String userPhone;

    @ExcelProperty(value = "报销原因")
    private String reason;

    @ExcelProperty(value = "费用承担方")
    private String payer;

    @ExcelProperty(value = "申请金额")
    private String applyAmount;

    @ExcelProperty(value = "客户支付凭证", converter = ListUrlConverterUtil.class)
    private List<URL> freightPaymentProof;

    @ExcelProperty(value = "客户收款码", converter = ListUrlConverterUtil.class)
    private List<URL> customerCodeImg;

    @ExcelProperty(value = "客户收款信息")
    private String customerAccountInfo;

    @ExcelProperty(value = "提交人姓名")
    private String createUser;

    @ExcelProperty(value = "客服备注")
    private String serviceRemarks;

    @ExcelProperty(value = "报销凭证", converter = ListUrlConverterUtil.class)
    private List<URL> reimbursementProof;

    @ExcelProperty(value = "报销状态")
    private String statusText;

    @ExcelProperty(value = "付款日期")
    private String reimbursementTime;

    @ExcelProperty(value = "报销金额")
    private String  returnedAmount;

    @ExcelProperty(value = "财务备注")
    private String  financialRemarks;

    @ExcelProperty(value = "付款人")
    private String  reimburserName;

    @ExcelProperty(value = "供应商名称")
    private String bankerName;


}
